---
title: "SQL-151 to SQL-183: Update operations"
summary: Update operations across this library — stored-procedure updates and inline UPDATE statements.
status: draft
owner: SAIF Documentation Generator
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# SQL-151 to SQL-183: Update operations

This page documents all 33 Update-type SQL operations (SQL-151 through SQL-183). Every inline `UpdateSQL` restates the primary key in its `SET` list with no optimistic-concurrency predicate; lost-update protection relies entirely on the `RowsAffected <> 1` check performed after execution.* Stored-procedure updates have their body retrieval marked unavailable for this run (Legends CLI offline); see [Procedures](../procedures/index.md).

## SQL-151 clsAcknowledgeList.updateAcknowledged

`clsAcknowledgeList.updateAcknowledged` — stored procedure call against `pk80001_legalnet.updateAcknowledged`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-151 |
| **Operation type** | Update |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAcknowledgeList` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.updateAcknowledged(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\Print\clsAcknowledgeList.vb`

---
## SQL-152 clsAppeal

`clsAppeal` — stored procedure call against `pk80001_legalnet.updateAppeal`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-152 |
| **Operation type** | Update |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAppeal` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.updateAppeal(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsAppeal.vb`

---
## SQL-153 clsAppealExtension

`clsAppealExtension` — stored procedure call against `pk80001_legalnet.updateAppealExtension`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-153 |
| **Operation type** | Update |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAppealExtension` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.updateAppealExtension(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsAppealExtension.vb`

---
## SQL-154 clsAttorneyConflict.Criteria.UpdateSQL

`clsAttorneyConflict.Criteria.UpdateSQL` — inline UPDATE against `ATTORNEY_CONFLICT`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-154 |
| **Operation type** | Update |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsAttorneyConflict` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ATTORNEY_CONFLICT](../database-tables.md#attorney_conflict) | UPDATE | See Sample SQL below |

### Sample SQL

```sql
-- Update against ATTORNEY_CONFLICT
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against ATTORNEY_CONFLICT in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyConflict.vb`

---
## SQL-155 clsAttorneyPolicyAssignment.Criteria.UpdateSQL

`clsAttorneyPolicyAssignment.Criteria.UpdateSQL` — inline UPDATE against `ATTORNEY_POLICY_ASSIGNMENT`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-155 |
| **Operation type** | Update |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsAttorneyPolicyAssignment` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ATTORNEY_POLICY_ASSIGNMENT](../database-tables.md#attorney_policy_assignment) | UPDATE | See Sample SQL below |

### Sample SQL

```sql
-- Update against ATTORNEY_POLICY_ASSIGNMENT
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against ATTORNEY_POLICY_ASSIGNMENT in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyPolicyAssignment.vb`

---
## SQL-156 clsAttorneyProfile

`clsAttorneyProfile` — stored procedure call against `pk80001_legalnet.updateAttyProfile`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-156 |
| **Operation type** | Update |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsAttorneyProfile` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.updateAttyProfile(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyProfile.vb`

---
## SQL-157 clsAttorneySchedule.Criteria.UpdateSQL

`clsAttorneySchedule.Criteria.UpdateSQL` — inline UPDATE against `ATTORNEY_SCHEDULE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-157 |
| **Operation type** | Update |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsAttorneySchedule` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ATTORNEY_SCHEDULE](../database-tables.md#attorney_schedule) | UPDATE | See Sample SQL below |

### Sample SQL

```sql
-- Update against ATTORNEY_SCHEDULE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against ATTORNEY_SCHEDULE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneySchedule.vb`

---
## SQL-158 clsAttorneyWorkerAssignment.Criteria.UpdateSQL

`clsAttorneyWorkerAssignment.Criteria.UpdateSQL` — inline UPDATE against `ATTORNEY_WORKER_ASSIGNMENT`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-158 |
| **Operation type** | Update |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsAttorneyWorkerAssignment` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ATTORNEY_WORKER_ASSIGNMENT](../database-tables.md#attorney_worker_assignment) | UPDATE | See Sample SQL below |

### Sample SQL

```sql
-- Update against ATTORNEY_WORKER_ASSIGNMENT
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against ATTORNEY_WORKER_ASSIGNMENT in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsAttorneyWorkerAssignment.vb`

---
## SQL-159 clsCaseCost.Criteria.UpdateSQL

`clsCaseCost.Criteria.UpdateSQL` — inline UPDATE against `CASE_COST`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-159 |
| **Operation type** | Update |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsCaseCost` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [CASE_COST](../database-tables.md#case_cost) | UPDATE | See Sample SQL below |

### Sample SQL

```sql
-- Update against CASE_COST
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against CASE_COST in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseCost.vb`

---
## SQL-160 clsCaseNote

`clsCaseNote` — stored procedure call against `pk80001_legalnet.case_note_update`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-160 |
| **Operation type** | Update |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsCaseNote` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.case_note_update(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseNote.vb`

---
## SQL-161 clsCaseOutcome

`clsCaseOutcome` — stored procedure call against `pk80001_legalnet.updateCaseOutcome`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-161 |
| **Operation type** | Update |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsCaseOutcome` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.updateCaseOutcome(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseOutcome.vb`

---
## SQL-162 clsCaseStatusHistory.Criteria.UpdateSQL

`clsCaseStatusHistory.Criteria.UpdateSQL` — inline UPDATE against `CASE_STATUS_HISTORY`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-162 |
| **Operation type** | Update |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsCaseStatusHistory` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [CASE_STATUS_HISTORY](../database-tables.md#case_status_history) | UPDATE | See Sample SQL below |

### Sample SQL

```sql
-- Update against CASE_STATUS_HISTORY
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against CASE_STATUS_HISTORY in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsCaseStatusHistory.vb`

---
## SQL-163 clsConsolidations.UpdateConsolidatedCase

`clsConsolidations.UpdateConsolidatedCase` — stored procedure call against `pk80001_legalnet.UpdateConsolidatedCase`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-163 |
| **Operation type** | Update |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsConsolidations` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.UpdateConsolidatedCase(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsConsolidations.vb`

---
## SQL-164 clsConsolidations.updateCaseStatus

`clsConsolidations.updateCaseStatus` — stored procedure call against `pk80001_legalnet.updateCaseStatus`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-164 |
| **Operation type** | Update |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsConsolidations` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.updateCaseStatus(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsConsolidations.vb`

---
## SQL-165 clsCreateFile.setFileCreateDate

`clsCreateFile.setFileCreateDate` — stored procedure call against `pk80001_legalnet.setFileCreateDate`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-165 |
| **Operation type** | Update |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsCreateFile` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.setFileCreateDate(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\Print\clsCreateFile.vb`

---
## SQL-166 clsHearingLocation.Criteria.UpdateSQL

`clsHearingLocation.Criteria.UpdateSQL` — inline UPDATE against `HEARING_LOCATION`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-166 |
| **Operation type** | Update |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsHearingLocation` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [HEARING_LOCATION](../database-tables.md#hearing_location) | UPDATE | See Sample SQL below |

### Sample SQL

```sql
-- Update against HEARING_LOCATION
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against HEARING_LOCATION in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsHearingLocation.vb`

---
## SQL-167 clsHearingLocationInfo.Criteria.UpdateSQL

`clsHearingLocationInfo.Criteria.UpdateSQL` — inline UPDATE against `HEARING_LOCATION`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-167 |
| **Operation type** | Update |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsHearingLocationInfo` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [HEARING_LOCATION](../database-tables.md#hearing_location) | UPDATE | See Sample SQL below |

### Sample SQL

```sql
-- Update against HEARING_LOCATION
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against HEARING_LOCATION in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsHearingLocationInfo.vb`

---
## SQL-168 clsLegalCase

`clsLegalCase` — stored procedure call against `pk80001_legalnet.UpdateLegalCase`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-168 |
| **Operation type** | Update |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsLegalCase` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.UpdateLegalCase(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalCase.vb`

---
## SQL-169 clsLegalCase.updateHearingSeqNum

`clsLegalCase.updateHearingSeqNum` — stored procedure call against `pk80001_legalnet.updateHearingSeqNum`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-169 |
| **Operation type** | Update |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsLegalCase` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.updateHearingSeqNum(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalCase.vb`

---
## SQL-170 clsLegalCaseEvaluation

`clsLegalCaseEvaluation` — stored procedure call against `pk80001_legalnet.updateLCE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-170 |
| **Operation type** | Update |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsLegalCaseEvaluation` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.updateLCE(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalCaseEvaluation.vb`

---
## SQL-171 clsLegalFileLocation

`clsLegalFileLocation` — stored procedure call against `pk80001_legalnet.updateFileLocation`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-171 |
| **Operation type** | Update |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsLegalFileLocation` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.updateFileLocation(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalFileLocation.vb`

---
## SQL-172 clsLegalPerson.Criteria.UpdateSQL

`clsLegalPerson.Criteria.UpdateSQL` — inline UPDATE against `LEGAL_PERSON`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-172 |
| **Operation type** | Update |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsLegalPerson` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_PERSON](../database-tables.md#legal_person) | UPDATE | See Sample SQL below |

### Sample SQL

```sql
-- Update against LEGAL_PERSON
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against LEGAL_PERSON in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsLegalPerson.vb`

---
## SQL-173 clsLegalPersonType.Criteria.UpdateSQL

`clsLegalPersonType.Criteria.UpdateSQL` — inline UPDATE against `LEGAL_PERSON_TYPE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-173 |
| **Operation type** | Update |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsLegalPersonType` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_PERSON_TYPE](../database-tables.md#legal_person_type) | UPDATE | See Sample SQL below |

### Sample SQL

```sql
-- Update against LEGAL_PERSON_TYPE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against LEGAL_PERSON_TYPE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsLegalPersonType.vb`

---
## SQL-174 clsLegalSchedule

`clsLegalSchedule` — stored procedure call against `pk80001_legalnet.updateSchedule`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-174 |
| **Operation type** | Update |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsLegalSchedule` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.updateSchedule(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsLegalSchedule.vb`

---
## SQL-175 clsLetterRequest.UpdateLetterRequest

`clsLetterRequest.UpdateLetterRequest` — stored procedure call against `pk82289_legalnet_letters.UpdateLetterRequest`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-175 |
| **Operation type** | Update |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsLetterRequest` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk82289_legalnet_letters.UpdateLetterRequest(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\Print\clsLetterRequest.vb`

---
## SQL-176 clsMailDate.setMailDate

`clsMailDate.setMailDate` — stored procedure call against `pk80001_legalnet.setMailDate`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-176 |
| **Operation type** | Update |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsMailDate` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.setMailDate(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\Print\clsMailDate.vb`

---
## SQL-177 clsMailDate.setMailOARFlag

`clsMailDate.setMailOARFlag` — stored procedure call against `pk80001_legalnet.setMailOARFlag`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-177 |
| **Operation type** | Update |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | StoredProcedure |
| **Business object** | `clsMailDate` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| — | — | Table not directly identifiable from call-site evidence** |

### Sample SQL

```sql
-- Stored procedure call
CALL pk80001_legalnet.setMailOARFlag(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)
```

### Sources
- `SAIF.Business.Claim.Legal\Print\clsMailDate.vb`

---
## SQL-178 clsOtherFirm.Criteria.UpdateSQL

`clsOtherFirm.Criteria.UpdateSQL` — inline UPDATE against `OTHER_FIRM`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-178 |
| **Operation type** | Update |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOtherFirm` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [OTHER_FIRM](../database-tables.md#other_firm) | UPDATE | See Sample SQL below |

### Sample SQL

```sql
-- Update against OTHER_FIRM
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against OTHER_FIRM in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsOtherFirm.vb`

---
## SQL-179 clsOtherLegalParty.Criteria.UpdateSQL

`clsOtherLegalParty.Criteria.UpdateSQL` — inline UPDATE against `LEGAL_CASE_EMPLOYER`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-179 |
| **Operation type** | Update |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOtherLegalParty` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_CASE_EMPLOYER](../database-tables.md#legal_case_employer) | UPDATE | See Sample SQL below |

### Sample SQL

```sql
-- Update against LEGAL_CASE_EMPLOYER
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against LEGAL_CASE_EMPLOYER in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsOtherLegalParty.vb`

---
## SQL-180 clsOutcomeIssue.Criteria.UpdateSQL

`clsOutcomeIssue.Criteria.UpdateSQL` — inline UPDATE against `OUTCOME_ISSUE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-180 |
| **Operation type** | Update |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOutcomeIssue` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [OUTCOME_ISSUE](../database-tables.md#outcome_issue) | UPDATE | See Sample SQL below |

### Sample SQL

```sql
-- Update against OUTCOME_ISSUE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against OUTCOME_ISSUE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsOutcomeIssue.vb`

---
## SQL-181 clsOutcomeStaff.Criteria.UpdateSQL

`clsOutcomeStaff.Criteria.UpdateSQL` — inline UPDATE against `OUTCOME_STAFF`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-181 |
| **Operation type** | Update |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOutcomeStaff` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [OUTCOME_STAFF](../database-tables.md#outcome_staff) | UPDATE | See Sample SQL below |

### Sample SQL

```sql
-- Update against OUTCOME_STAFF
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against OUTCOME_STAFF in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsOutcomeStaff.vb`

---
## SQL-182 clsOutOFTownRotationAssgn.Criteria.UpdateSQL

`clsOutOFTownRotationAssgn.Criteria.UpdateSQL` — inline UPDATE against `OUT_OF_TOWN_ROTATION_ASSGN`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-182 |
| **Operation type** | Update |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsOutOFTownRotationAssgn` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [OUT_OF_TOWN_ROTATION_ASSGN](../database-tables.md#out_of_town_rotation_assgn) | UPDATE | See Sample SQL below |

### Sample SQL

```sql
-- Update against OUT_OF_TOWN_ROTATION_ASSGN
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against OUT_OF_TOWN_ROTATION_ASSGN in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\TableMaint\clsOutOFTownRotationAssgn.vb`

---
## SQL-183 clsRequestIssue.Criteria.UpdateSQL

`clsRequestIssue.Criteria.UpdateSQL` — inline UPDATE against `REQUEST_ISSUE`.

### Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-183 |
| **Operation type** | Update |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsRequestIssue` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`) |

### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [REQUEST_ISSUE](../database-tables.md#request_issue) | UPDATE | See Sample SQL below |

### Sample SQL

```sql
-- Update against REQUEST_ISSUE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against REQUEST_ISSUE in this library.*
```

### Sources
- `SAIF.Business.Claim.Legal\LegalNet\clsRequestIssue.vb`

---
## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [SQL catalog](index.md)
- [API reference](../api/index.md)

> **Note:** Statements marked with `*` were inferred from code structure, naming
> conventions, or contextual evidence where direct confirmation was not available
> in source artifacts. Statements marked with `**` could not be confirmed; treat
> as unknown until verified.

## Sources
- See per-SQL-ID Sources subsections above for exact .vb file/line citations.